class CreateUserItemInterest < ActiveRecord::Migration
  def self.up
  	create_table (:user_item_interests, :options=>'ENGINE=InnoDB DEFAULT CHARSET=utf8',:force => true) do |t|
  		t.integer	:user_id, :null => false
  		t.integer	:item_id, :null => false
  		t.integer	:interest,	:limit => 4, :default => 0
  		t.integer	:status,	:limit => 1, :default => 0
  		t.integer	:flag,		:limit => 4, :default => 0
  		t.timestamps
  	end
  end

  def self.down
  	drop_table	:user_item_interests
  end
end
